﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ReportGetRZFXBP.aspx.cs" Inherits="IHISCETeim.Web.MachineSys.FXModel.ReportGetRZFXBP" %>
<%--经销商融资分析报表--%>
 <form id="pagerForm" method="post" action="FXModel/ReportGetRZFXBP.aspx">
 <input type="hidden" name="LeaseCompany" value="<%=LeaseCompany %>" />
 <input type="hidden" name="AliasName" value="<%=AliasName %>" />
 <input type="hidden" name="orderField" value="<%=orderField %>" />
<input type="hidden" name="orderDirection" value="<%=orderDirection %>" />
 </form>
 <form id="ReportGetRZFXBPFrom" runat="server" method="post" action="FXModel/ReportGetRZFXBP.aspx" onsubmit="return navTabSearch(this);">

<div class="pageHeader" style="overflow:hidden!important;">
    <div class="searchBar">
        <table class="searchContent">
            <tr>
                <td>租赁公司：</td>
                <td> 
                    <select name="LeaseCompany" onchange="$('#ReportGetRZFXBPFrom_AliasName').val(''); return navTabSearch(ReportGetRZFXBPFrom)">
                    <%=GetLeaseCompany(LeaseCompany)%>
                    </select>
                </td>
                <td>经销商:</td>
                <td>
                    <select id="ReportGetRZFXBPFrom_AliasName" name="AliasName" onchange="return navTabSearch(ReportGetRZFXBPFrom)">
                        <%=GetAliasNameList()%>
                    </select>
                </td>
               
                <td>
                     <div class="subBar">
                        <ul>
                            <li>
                                <div class="buttonActive"><div class="buttonContent"><a href="<%=ExportExcelWebUrl %>/FXModel/ReportGetRZFXBP.aspx?LeaseCompany=<%=HttpUtility.UrlEncode(LeaseCompany) %>" target="_blank" title="确定要导出吗?" style=" line-height:25px!important;" >导出</a></div></div>
                            </li>
                        </ul>
                    </div>
                </td>    
                <td>
                    逾期数据更新时间:<b style="color:red;"><%=IHISCETeim.BLL.FXFinanceLeaseController.GetLastRefresDate()%></b>
                </td>                
            </tr>
        </table>  
    </div>
</div>
<div class="pageContent" style=" padding:10px;" layouth="60"> 
    <h2 style=" margin:5px 0px;">所有客户:</h2>
    <table class="list" style="width:90%; border:2px solid #000; ">
        <tr>
            <th >客户总数:</th>
            <td colspan="4"><%=dt1["总客户数"]%></td>
           
        </tr>
        <tr>
            <th>剩余债权总额:</th>
            <td colspan="4"><%= FormatDecimalToStrings(dt1["剩余租金"], "N")%></td>
        </tr>
        <tr>
            <th>逾期债权比例:</th>
            <td colspan="4"><%=GetPer(Convert.ToDouble(dt1["逾期1期客户剩余租金"]) + Convert.ToDouble(dt1["逾期2期客户剩余租金"]) + Convert.ToDouble(dt1["逾期3期及以上客户剩余租金"]), dt1["剩余租金"])%>%</td>
            
        </tr>
        
        <tr>
            <th width="25%">&nbsp;</th>
            <th width="15%">客户数</th>
            <th width="15%">比例</th>
            <th width="15%">剩余债权</th>
            <th width="30%">比例</th>
        </tr>
        <tr>
            <th>无逾期客户</th>
            <td><%=dt1["无逾期客户数"]%></td>
            <td><%=GetPer(dt1["无逾期客户数"], dt1["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt1["无逾期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt1["无逾期客户剩余租金"], dt1["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期1期客户</th>
            <td><%=dt1["逾期1期客户数"]%></td>
            <td><%=GetPer(dt1["逾期1期客户数"], dt1["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt1["逾期1期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt1["逾期1期客户剩余租金"], dt1["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期2期客户</th>
             <td><%=dt1["逾期2期客户数"]%></td>
            <td><%=GetPer(dt1["逾期2期客户数"], dt1["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt1["逾期2期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt1["逾期2期客户剩余租金"], dt1["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期3期客户及以上客户</th>
             <td><%=dt1["逾期3期及以上客户数"]%></td>
            <td><%=GetPer(dt1["逾期3期及以上客户数"], dt1["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt1["逾期3期及以上客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt1["逾期3期及以上客户剩余租金"], dt1["剩余租金"])%>%</td>
        </tr>
    </table>


    <h2 style=" margin:5px 0px;">6期之内新客户:</h2>
    <table class="list" style="width:90%; border:2px solid #000; ">
        <tr>
            <th >客户总数:</th>
            <td colspan="4"><%=dt2["总客户数"]%></td>
           
        </tr>
        <tr>
            <th>剩余债权总额:</th>
            <td colspan="4"><%= FormatDecimalToStrings(dt2["剩余租金"], "N")%></td>
        </tr>
        <tr>
            <th>逾期债权比例:</th>
            <td colspan="4"><%=GetPer(Convert.ToDouble(dt2["逾期1期客户剩余租金"]) + Convert.ToDouble(dt2["逾期2期客户剩余租金"]) + Convert.ToDouble(dt2["逾期3期及以上客户剩余租金"]), dt2["剩余租金"])%>%</td>
            
        </tr>
        
        <tr>
            <th width="25%">&nbsp;</th>
            <th width="15%">客户数</th>
            <th width="15%">比例</th>
            <th width="15%">剩余债权</th>
            <th width="30%">比例</th>
        </tr>
        <tr>
            <th>无逾期客户</th>
            <td><%=dt2["无逾期客户数"]%></td>
            <td><%=GetPer(dt2["无逾期客户数"], dt2["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt2["无逾期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt2["无逾期客户剩余租金"], dt2["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期1期客户</th>
            <td><%=dt2["逾期1期客户数"]%></td>
            <td><%=GetPer(dt2["逾期1期客户数"], dt2["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt2["逾期1期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt2["逾期1期客户剩余租金"], dt2["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期2期客户</th>
             <td><%=dt2["逾期2期客户数"]%></td>
            <td><%=GetPer(dt2["逾期2期客户数"], dt2["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt2["逾期2期客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt2["逾期2期客户剩余租金"], dt2["剩余租金"])%>%</td>
        </tr>
        <tr>
            <th>逾期3期客户及以上客户</th>
             <td><%=dt2["逾期3期及以上客户数"]%></td>
            <td><%=GetPer(dt2["逾期3期及以上客户数"], dt2["总客户数"])%>%</td>
            <td><%=FormatDecimalToStrings(dt2["逾期3期及以上客户剩余租金"], "N")%></td>
            <td><%=GetPer(dt2["逾期3期及以上客户剩余租金"], dt2["剩余租金"])%>%</td>
        </tr>
    </table>
</div>

</form>